-
Re: Hi - I need help with this formula. I am getting UNPARSEABLE error with it each time
Very close Suumit. I think the only issue in what you have is that you need to make the next nested IF statement the FALSE part of your first if statement instead of a new statement entirely. So it w…1 · -
Re: Formula to return % of opportunities won
I can't quite see those in enough detail to tell what is what as far as the column names go, but this is the general idea. First, you need to number of opportunities that are for that salesperson who…1 · -
Re: Returning to a Form for a Specific Row
I don't believe this is possible in current state. As you said, you can do Update Requests, but Forms are for inputs into the sheet and won't auto-fill with row data. I would recommend that you put t…1 · -
Re: Automated formula for dates
Instead of using DATE, have you looked into using MONTH? If you do that, and add 1 more column that numbers your rows 1-12, then point the MONTH formula to the month number on the row, you would not …1 · -
Re: Managing Smartsheet templates and workspaces after 3 years
I can't claim this as my own idea because I saw this from another Smartsheet user in a webinar and started implementing it. Now that Smartsheet offers Sheet level comments, we store this type of info…1 ·